const express=require ('express');
const router=express.Router();
const {D_ICPMS}=require ('../../models');
const Sequelize = require('sequelize');
const Op=Sequelize.Op;
router.get('/',async function(req,res){
    const UPbTeraWasserburg =await D_ICPMS.findAll({
        attributes: ['D_238U_206Pb_measured', 'D_238U_206Pb_measured_1SE',"D_207Pb_206Pb_measured", "D_207Pb_206Pb_measured_1SE"],
        where: {
            D_238U_206Pb_measured:{
                [Op.ne]: null,
            },
            // D_238U_206Pb_measured_1SE:{
            //     [Op.ne]: null,
            // },
            D_207Pb_206Pb_measured:{
                [Op.ne]: null,
            },
            // D_207Pb_206Pb_measured_1SE:{
            //     [Op.ne]: null,
            // }
        },
        limit:400
      });
    res.json(
        {
            status:true,
            message:'查询成功！',
            data:{

                UPbTeraWasserburg
            }
        }
    )
})

module.exports=router;